{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Polecenia","zadanie 1","zadanie 2","zadanie 3","zadanie 4","zadanie 5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Polecenia","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[3,1,3,4]]}
["Nr grupy","Nazwisko","Imię","Nr albumu","Data","Nr zadania","Termin","Czas przygotowań [h]"]
[1,null,null,null,"2019-07-02",1,"pierwszy"]
[]
[null,{"$f":"IF(OR(A2=\"\",B2=\"\",C2=\"\",D2=\"\"),\"UZUPEŁNIJ SWOJE DANE!\",\"\")","v":"UZUPEŁNIJ SWOJE DANE!"}]
[]
[null,"Zasady kolokwium:"]
[null,"1. Zadania rozwiązywane SAMODZIELNIE - zabroniony jest kontakt z osobami w laboratorium jak i poza nim."]
[null,"2. Dozwolone materiały pomocnicze: notatki, książki."]
[null,"3. Wyniki należy umieszczać w żółtych polach obok wyszczególnionych statystyk!"]
[null,"4. Nie wolno zaokrąglać wyników!"]
[null,"5. Nie wolno zmieniać nazw istniejących arkuszy ani nazwy pliku."]
[null,"6. Plik należy przesłać do godziny 10:00 na adres Jacek.Szandula@ue.wroc.pl. W tytule maila podać (numer grupy) (przecinek) (spacja) (nazwisko) np.: 12, Kowalski"]
[]
[null,"Po kolokwium:"]
[null,"1. Ze strony szandulajacek.republika.pl należy pobrać plik z rozwiązanymi zadaniami."]
[null,"2. Aby sprawdzić poprawność rozwiązanych zadań należy:"]
[null,null,"a) otworzyć swój plik, przejść do arkusza zadanie 1, skopiować obszar odpowiedzi (czarna ramka), "]
[null,null,"b) otworzyć plik z rozwiązaniami, przejść do arkusza zadanie 1, zaznaczyć obszar odpowiedzi (czarna ramka),"]
[null,null,"c) wybrać polecenie WKLEJ SPECJALNIE, zaznaczyć opcję WARTOŚCI I FORMATY LICZB,"]
[null,null,"d) powtórzyć kroki a - c dla pozostałych zadań."]
[null,"3. Uzyskany wynik można odczytać w arkuszu Polecenia pliku z rozwiązaniami zadań."]
[]
[]
[]
[{"$f":"ADDRESS(ROW('zadanie 1'!H2),COLUMN('zadanie 1'!H2),4,1)","v":"H2"},{"$f":"ADDRESS(ROW('zadanie 1'!M13),COLUMN('zadanie 1'!M13),4,1)","v":"M13"}]
[{"$f":"ADDRESS(ROW('zadanie 2'!I2),COLUMN('zadanie 2'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 2'!N12),COLUMN('zadanie 2'!N12),4,1)","v":"N12"}]
[{"$f":"ADDRESS(ROW('zadanie 3'!H3),COLUMN('zadanie 3'!H3),4,1)","v":"H3"},{"$f":"ADDRESS(ROW('zadanie 3'!L14),COLUMN('zadanie 3'!L14),4,1)","v":"L14"}]
[{"$f":"ADDRESS(ROW('zadanie 4'!I2),COLUMN('zadanie 4'!I2),4,1)","v":"I2"},{"$f":"ADDRESS(ROW('zadanie 4'!M25),COLUMN('zadanie 4'!M25),4,1)","v":"M25"}]
[{"$f":"ADDRESS(ROW('zadanie 5'!I4),COLUMN('zadanie 5'!I4),4,1)","v":"I4"},{"$f":"ADDRESS(ROW('zadanie 5'!Q17),COLUMN('zadanie 5'!Q17),4,1)","v":"Q17"}]

{"sheet":"zadanie 1","index":1,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[[10,8,10,10],[11,8,11,10],[12,8,12,10],[2,8,2,10],[3,8,3,10],[4,8,4,10],[7,8,7,10],[8,8,8,10],[9,8,9,10]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży określ składowe szeregu czasowego"]
[1,10736.42,null,null,null,null,null,"a) Przeprowadź test współczynnika korelacji; α = 0,05"]
[2,13182.44,null,null,null,null,null,null,"Współczynnik korelacji = "]
[3,18020.900000000001,null,null,null,null,null,null,"Statystyka testowa = "]
[4,20142.939999999999,null,null,null,null,null,null,"Wartość krytyczna  ="]
[5,21069.03]
[6,23275.57,null,null,null,null,null,"b) Składowe szeregu czasowego"]
[7,26019.57,null,null,null,null,null,null,"Wahania przypadkowe"]
[8,26744.84,null,null,null,null,null,null,"Stały poziom"]
[9,28014.63,null,null,null,null,null,null,"Trend malejący"]
[10,30153.51,null,null,null,null,null,null,"Trend rosnący"]
[11,31355.86,null,null,null,null,null,null,"Wahania sezonowe"]
[12,32025.67,null,null,null,null,null,null,"Wahania cykliczne"]
[13,34311.99]
[14,32887.69]
[15,35180.78]
[16,37600.129999999997]
[17,38471.910000000003]
[18,37698.58]
[19,40841.440000000002]
[20,41320.769999999997]
[21,40762.58]
[22,46145.7]
[23,45201.33]
[24,43257.11]
[25,45902.73]
[26,47505.82]
[27,47980.69]
[28,49017.46]
[29,49624.95]
[30,50889.9]
[31,50073.53]
[32,51155.29]
[33,52096.04]
[34,52956.43]
[35,52954]
[36,53886.73]
[37,55029.82]
[38,55519.63]
[39,55063.79]
[40,56855.37]
[41,57655.09]
[42,58139.46]
[43,60679.69]
[44,60086.879999999997]
[45,59780.06]
[46,60805.89]
[47,61779.85]
[48,62234.21]
[49,63627.86]
[50,64508.67]
[51,66052.69]
[52,62336.76]
[53,65325]
[54,64817.64]
[55,65357.58]
[56,65416.74]
[57,67984.649999999994]
[58,67572.72]
[59,68259.259999999995]
[60,69091.42]
[61,70097.13]
[62,71610.429999999993]
[63,71759.97]
[64,71106]
[65,71724.23]

{"sheet":"zadanie 2","index":2,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[8,12,8,13],[2,9,2,11],[3,9,3,11],[5,9,5,11],[6,9,6,11],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie tygodniowych wartości sprzedaży w zł wyznacz:"]
[1,1764.31,null,null,null,null,null,null,"a) parametry modelu"]
[2,2032.32,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,1787.87,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,1719.25,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[5,2027.54,null,null,null,null,null,null,null,"Współczynnik determinacji ="]
[6,1960.78,null,null,null,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[7,2198.65,null,null,null,null,null,null,"c) Uzupełnij poniższą tabelę"]
[8,1868.45,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Bezwzględny błąd prognozy ex ante","Względny błąd prognozy ex ante","Prognoza przedziałowa (p = 0,9)"]
[9,1881.59,null,null,null,null,null,null,null,null,null,null,"od","do"]
[10,1953.4,null,null,null,null,null,null,89]
[11,2105.02,null,null,null,null,null,null,90]
[12,1994.44]
[13,2102.0700000000002]
[14,2135.1]
[15,2248.6999999999998]
[16,2036.1]
[17,2149.04]
[18,2385.5100000000002]
[19,2185.7800000000002]
[20,1971.04]
[21,2401.09]
[22,2271.89]
[23,2353.9]
[24,2456.62]
[25,2145.8000000000002]
[26,2354.44]
[27,2433.23]
[28,2535.25]
[29,2246.69]
[30,2682.22]
[31,2349.8200000000002]
[32,2462.11]
[33,2604.89]
[34,2590.23]
[35,2681.56]
[36,2716.11]
[37,2866.15]
[38,2509.7399999999998]
[39,2700.18]
[40,2707.61]
[41,2791.16]
[42,2801.33]
[43,2963.38]
[44,2800.29]
[45,2941.45]
[46,3011.87]
[47,2974.56]
[48,3046.11]
[49,3082.6]
[50,2931.88]
[51,2909.62]
[52,3195.78]
[53,2977.43]
[54,3061.01]
[55,3005.72]
[56,2994.78]
[57,3077.17]
[58,3265.8]
[59,3125.78]
[60,3346.71]
[61,3229.18]
[62,3193.84]
[63,3101.71]
[64,3257.68]
[65,3207.17]
[66,3361.99]
[67,3510.37]
[68,3398.23]
[69,3276.95]
[70,3496.07]
[71,3540.2]
[72,3497.63]
[73,3578.89]
[74,3452.54]
[75,3511.55]
[76,3521.89]
[77,3439.13]
[78,3589.94]
[79,3666.6]
[80,3608.41]
[81,3758.37]
[82,3652.84]
[83,3976.01]
[84,3790.17]
[85,4081.99]
[86,3987.71]
[87,3660.08]
[88,3770.9]

{"sheet":"zadanie 3","index":3,"n_rows":50,"n_cols":12,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,8,3,10],[4,8,4,10],[5,8,5,10],[6,8,6,10],[7,8,7,10],[10,8,11,8],[10,9,11,9],[10,10,11,10]]}
["Nr okresu","Sprzedaż w tys. zł",null,null,null,null,null,"Przy pomocy Solvera dokonaj optymalizacji modelu Holta przyjmując: F1 = y1, S1 = y2 – y1. "]
[1,0.7,null,null,null,null,null,"Optymalizację przeprowadź dla punktów startowych α = 0,5, β = 0,5."]
[2,2.1,null,null,null,null,null,"a) Wyznacz"]
[3,1.3,null,null,null,null,null,null,"α =",null,null,0.5]
[4,3.1,null,null,null,null,null,null,"β =",null,null,0.5]
[5,3.4,null,null,null,null,null,null,"s* ="]
[6,3.2,null,null,null,null,null,null,"Fn ="]
[7,5.2,null,null,null,null,null,null,"Sn ="]
[8,7.2]
[9,6,null,null,null,null,null,"b) Uzupełnij poniższą tabelę"]
[10,8.1999999999999993,null,null,null,null,null,null,"Nr okresu","Prognoza punktowa","Względny błąd prognozy"]
[11,7.7]
[12,8.6,null,null,null,null,null,null,50]
[13,7.6,null,null,null,null,null,null,51]
[14,7.8]
[15,7.1]
[16,7]
[17,7.6]
[18,6.7]
[19,8.8000000000000007]
[20,6.3]
[21,7.9]
[22,8]
[23,7.6]
[24,7.5]
[25,6.8]
[26,6.9]
[27,8]
[28,7.1]
[29,6.8]
[30,7.8]
[31,6.2]
[32,7.4]
[33,5.9]
[34,6.8]
[35,7.4]
[36,7.1]
[37,8.1]
[38,9]
[39,9.1]
[40,9.8000000000000007]
[41,10.199999999999999]
[42,9.1999999999999993]
[43,9.4]
[44,8.1]
[45,9.6]
[46,7]
[47,6.9]
[48,5.9]
[49,5]

{"sheet":"zadanie 4","index":4,"n_rows":61,"n_cols":13,"rows_kept":61,"cut":false,"hidden":false,"merged":[[20,12,21,12],[2,9,2,11],[3,9,3,11],[4,9,4,11],[18,9,18,11],[20,10,21,10],[20,11,21,11]]}
["Nr okresu","Sprzedaż w zł",null,"Na podstawie danych miesięcznych o wartości sprzedaży w zł wyznacz:"]
[1,16315.79,null,null,null,null,null,null,"a) parametry modelu"]
[2,16475.36,null,null,null,null,null,null,null,"Wyraz wolny ="]
[3,17432.330000000002,null,null,null,null,null,null,null,"Współczynnik kierunkowy ="]
[4,18074.96,null,null,null,null,null,null,null,"wskaźniki sezonowości"]
[5,14989.74,null,null,null,null,null,null,null,null,null,"c1 ="]
[6,12784.84,null,null,null,null,null,null,null,null,null,"c2 ="]
[7,14776.24,null,null,null,null,null,null,null,null,null,"c3 ="]
[8,16094.45,null,null,null,null,null,null,null,null,null,"c4 ="]
[9,14426.42,null,null,null,null,null,null,null,null,null,"c5 ="]
[10,14574.49,null,null,null,null,null,null,null,null,null,"c6 ="]
[11,16688.54,null,null,null,null,null,null,null,null,null,"c7 ="]
[12,12664.15,null,null,null,null,null,null,null,null,null,"c8 ="]
[13,13567.3,null,null,null,null,null,null,null,null,null,"c9 ="]
[14,13804.89,null,null,null,null,null,null,null,null,null,"c10 ="]
[15,15526.08,null,null,null,null,null,null,null,null,null,"c11 ="]
[16,15127.99,null,null,null,null,null,null,null,null,null,"c12 ="]
[17,14574.89,null,null,null,null,null,null,"b) Miary dopasowania modelu"]
[18,11720.13,null,null,null,null,null,null,null,"Względny poziom reszt ="]
[19,12823.07,null,null,null,null,null,null,"c) Prognozy na podane okresy"]
[20,13806.11,null,null,null,null,null,null,null,null,"Nr okresu","Prognoza wstępna","Prognoza ostateczna"]
[21,13046.43]
[22,13879.88,null,null,null,null,null,null,null,null,61]
[23,14963.69,null,null,null,null,null,null,null,null,62]
[24,10827.96,null,null,null,null,null,null,null,null,63]
[25,12663.18]
[26,12926.92]
[27,12760.02]
[28,12935.22]
[29,12127.29]
[30,9380.5]
[31,10467.5]
[32,12445.74]
[33,9975.9]
[34,10925.92]
[35,12198.33]
[36,9806.7800000000007]
[37,10358.85]
[38,11388.73]
[39,11266.98]
[40,12314.61]
[41,10524.88]
[42,7967.37]
[43,9355.34]
[44,9727.42]
[45,9062.7900000000009]
[46,10021.700000000001]
[47,11731.78]
[48,7305.69]
[49,8817.58]
[50,9292.4699999999993]
[51,8765.4]
[52,10866.87]
[53,7987.07]
[54,5116.55]
[55,6924.9]
[56,8269.43]
[57,6782.12]
[58,8483.08]
[59,8666.68]
[60,6106.58]

{"sheet":"zadanie 5","index":5,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[[14,14,15,14],[14,15,14,16],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[4,9,4,11],[5,9,5,11],[6,9,6,11],[7,9,7,11],[10,9,10,11],[11,9,11,11]]}
["Nr okresu","Y","X1","X2","X3",null,null,null,"Na podstawie wartości zmiennych Y, X1, X2 i X3 zbuduj model ekonometryczny wyjaśniający zmienną Y"]
[1,233.2,35.18,36.32,423.6,null,null,null,"Poziom istotności dla oceny parametrów modelu przyjmij α = 0,05"]
[2,243.7,31.59,37.86,458,null,null,null,"Wyznacz"]
[3,272.89999999999998,33.9,27.96,536.1,null,null,null,"a) parametry modelu"]
[4,260.8,29.43,32.299999999999997,517.4,null,null,null,null," α0 ="]
[5,199.9,28.01,31.63,384.4,null,null,null,null," α1 ="]
[6,157.1,25.83,42.19,293.60000000000002,null,null,null,null," α2 ="]
[7,225.6,30.25,36.01,464.1,null,null,null,null," α3 ="]
[8,284,30.89,31.83,610.5]
[9,200.4,28.27,31.64,424.4,null,null,null,"b) Miary dopasowania modelu"]
[10,230.4,27.58,34.71,504.4,null,null,null,null,"Współczynnik determinacji ="]
[11,244.1,27.82,32.549999999999997,546.1,null,null,null,null,"Standardowy błąd oceny  modelu ="]
[12,202.5,23.88,30.93,458.3]
[13,185.3,24.08,31.14,427.7,null,null,null,"c) Uzupełnij poniższą tabelę."]
[14,174.9,17.91,30.48,413,null,null,null,"Nr okresu","Prognoza punktowa X1","Prognoza punktowa X2","Prognoza punktowa X3","Prognoza punktowa Y","Bezwzględny błąd prognozy ex ante dla Y","Względny błąd prognozy ex ante dla Y","Prognoza przedziałowa dla Y (p = 0,9)"]
[15,235.3,25.92,24.2,564.29999999999995,null,null,null,null,null,null,null,null,null,null,"od","do"]
[16,296.3,25.61,16.12,717,null,null,null,26,16.803899999999995,26.386399999999995,558.46900000000005]
[17,157.69999999999999,20.76,34.61,401.7]
[18,223.6,23.63,23.78,565.79999999999995]
[19,196.1,17.79,30.55,511.2]
[20,198.3,19.62,32.770000000000003,526]
[21,268.5,20.65,24.66,700.1]
[22,207.4,20.23,26.96,566.70000000000005]
[23,208.2,21.4,26.96,578.29999999999995]
[24,124.7,16.27,34.29,392.4]
[25,169.1,19.5,28.61,506]